How to use bind variables with Zend_Db_Table->update() in the where clause?

You are only updating data, RDBMS (I assume MySQL) doesn't cache UPDATE queries. If you still want to use bind variables (security? Performance?), you will have to use prepared statements: $db = Zend_Db_Table_Abstract::getDefaultAdapter(); $stmt = $db->prepare("UPDATE table SET key = :key, value = :value"); foreach ($data as $key=>$value) { $stmt->bindParam('key', $key); $stmt->bindParam('value', $value); $stmt->execute(); } But unless you are having millions of UPDATE queries in a batch I don't think you should bother with this.

Just use the $table->update($data, $where).

Thanks. I am using Oracle in an internal corporate application. You're correct, performance isn't an issue as such - I asked this question because I like to follow best practices where possible.So I can either rewrite my code as you suggest or accept this limitation with Zend_Db_Table.

It's disapointing, because it is only the WHERE clause that is not bound - the SET clause does use bound variables under the hood. You would think they would provide a way to use bound variables for all parts of the query. – asgeo1 Oct 23 '09 at 1:23.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.